#region Copyright (c) 2006-2012 nHydrate.org, All Rights Reserved
// --------------------------------------------------------------------- *
//                           NHYDRATE.ORG                                *
//              Copyright (c) 2006-2012 All Rights reserved              *
//                                                                       *
//                                                                       *
// This file and its contents are protected by United States and         *
// International copyright laws.  Unauthorized reproduction and/or       *
// distribution of all or any portion of the code contained herein       *
// is strictly prohibited and will result in severe civil and criminal   *
// penalties.  Any violations of this copyright will be prosecuted       *
// to the fullest extent possible under law.                             *
//                                                                       *
// THE SOURCE CODE CONTAINED HEREIN AND IN RELATED FILES IS PROVIDED     *
// TO THE REGISTERED DEVELOPER FOR THE PURPOSES OF EDUCATION AND         *
// TROUBLESHOOTING. UNDER NO CIRCUMSTANCES MAY ANY PORTION OF THE SOURCE *
// CODE BE DISTRIBUTED, DISCLOSED OR OTHERWISE MADE AVAILABLE TO ANY     *
// THIRD PARTY WITHOUT THE EXPRESS WRITTEN CONSENT OF THE NHYDRATE GROUP *
//                                                                       *
// UNDER NO CIRCUMSTANCES MAY THE SOURCE CODE BE USED IN WHOLE OR IN     *
// PART, AS THE BASIS FOR CREATING A PRODUCT THAT PROVIDES THE SAME, OR  *
// SUBSTANTIALLY THE SAME, FUNCTIONALITY AS THIS PRODUCT                 *
//                                                                       *
// THE REGISTERED DEVELOPER ACKNOWLEDGES THAT THIS SOURCE CODE           *
// CONTAINS VALUABLE AND PROPRIETARY TRADE SECRETS OF NHYDRATE,          *
// THE REGISTERED DEVELOPER AGREES TO EXPEND EVERY EFFORT TO             *
// INSURE ITS CONFIDENTIALITY.                                           *
//                                                                       *
// THE END USER LICENSE AGREEMENT (EULA) ACCOMPANYING THE PRODUCT        *
// PERMITS THE REGISTERED DEVELOPER TO REDISTRIBUTE THE PRODUCT IN       *
// EXECUTABLE FORM ONLY IN SUPPORT OF APPLICATIONS WRITTEN USING         *
// THE PRODUCT.  IT DOES NOT PROVIDE ANY RIGHTS REGARDING THE            *
// SOURCE CODE CONTAINED HEREIN.                                         *
//                                                                       *
// THIS COPYRIGHT NOTICE MAY NOT BE REMOVED FROM THIS FILE.              *
// --------------------------------------------------------------------- *
#endregion
using System;
using System.Linq;
using System.Collections.Generic;
using System.Text;
using nHydrate.Generator;
using nHydrate.Generator.Models;
using System.Collections;
using nHydrate.Generator.Common.Util;
using nHydrate.Generator.ProjectItemGenerators;

namespace nHydrate.Generator.Datasite
{
	class DatasiteViewItemTemplate : BaseScriptTemplate
	{
		private StringBuilder sb = new StringBuilder();
		private CustomView _item = null;
		private string _templateLocation = string.Empty;

		#region Constructors
		public DatasiteViewItemTemplate(ModelRoot model, CustomView item, string templateLocation)
			: base(model)
		{
			_item = item;
			_templateLocation = templateLocation;
		}
		#endregion

		#region BaseClassTemplate overrides
		public override string FileContent
		{
			get
			{
				this.GenerateContent();
				return sb.ToString();
			}
		}

		public override string FileName
		{
			get { return string.Format("view." + _item.PascalName + ".html"); }
		}
		#endregion

		#region GenerateContent
		private void GenerateContent()
		{
			try
			{
				var fileContent = Helpers.GetFileContent(new EmbeddedResourceName(_templateLocation + ".datasite-view-template.htm"));

				fileContent = fileContent.Replace("$databasename$", _model.ProjectName);
				fileContent = fileContent.Replace("$objectname$", _item.GetSQLSchema() + "." + _item.Name);

				var description = _item.Description;
				if (string.IsNullOrEmpty(description))
					description = "The " + _item.Name + " item";
				fileContent = fileContent.Replace("$objectdescription$", description);

				fileContent = fileContent.Replace("$pagetitle$", "[" + _item.Name + "] Documentation");
				fileContent = fileContent.Replace("$footertext$", "Powered by nHydrate &copy; " + DateTime.Now.Year);

				#region Column Table
				var tsb = new StringBuilder();
				tsb.AppendLine("<table class=\"subItem-item\">");
				tsb.AppendLine("<thead>");
				tsb.AppendLine("<tr>");
				tsb.AppendLine("<th>Name</th>");
				tsb.AppendLine("<th>Data type</th>");
				tsb.AppendLine("<th>Length</th>");
				tsb.AppendLine("<th>Allow Null</th>");
				tsb.AppendLine("<th>Comment</th>");
				tsb.AppendLine("</tr>");
				tsb.AppendLine("</thead>");

				tsb.AppendLine("<tbody>");
				foreach (var subItem in _item.GeneratedColumns)
				{
					tsb.AppendLine("<tr class=\"" + (((_item.GeneratedColumns.IndexOf(subItem) % 2) == 1) ? "t-odd-color" : string.Empty) + "\">");

					tsb.AppendLine("<td>" + subItem.Name + "</td>");
					tsb.AppendLine("<td>" + subItem.DatabaseType + "</td>");
					tsb.AppendLine("<td>" + subItem.GetLengthString() + "</td>");
					tsb.AppendLine("<td>" + subItem.AllowNull.ToString() + "</td>");
					tsb.AppendLine("<td class=\"description\">" + subItem.Description + "</td>");
					tsb.AppendLine("</tr>");
				}
				tsb.AppendLine("</tbody>");
				tsb.AppendLine("</table>");
				fileContent = fileContent.Replace("$columntable$", tsb.ToString());
				#endregion

				#region SQL
				var sql = nHydrate.Core.SQLGeneration.SQLEmit.GetSQLCreateView(_item);
				var lines = sql.Replace("\r", string.Empty).Split('\n');
				var newCode = new StringBuilder();
				sql = string.Join("\r\n", lines.Where(x => !x.StartsWith("--MODELID")).ToList());
				sql = nHydrate.Core.SQLGeneration.HTMLEmit.FormatHTMLSQL(sql);
				fileContent = fileContent.Replace("$sql$", sql);
				#endregion

				sb.Append(fileContent);
			}
			catch (Exception ex)
			{
				throw;
			}
		}
		#endregion
	}
}